Excel Level 3 (Advanced)

Students will learn various advanced techniques for analysing and manipulating data in Excel.

Lesson 1: Advanaced functions and formulas
Logical functions, Conditional functions, Financial functions, Text functions, Date functions
Array formulas

Lesson 2:Lookups and data tables
Using VLookup and HLookup functions
Using MATCH and INDEX
Creating data tables

Lesson 3: Advanced data management
Validating cell entries
Advanced filtering

Lesson 4:Advanced charting
Chart formatting options
Combination charts
Graphic elements

Lesson 5: PivotTables and PivotCharts
Working with PivotTables
Rearranging and Formatting PivotTables
Using PivotCharts

Lesson 6: Exporting and importing
Exporting and importing text files
Getting external data

Lesson 7: Analytical tools
Goal Seek and Solver
Scenarios

Lesson 8:Macros
Running and recording a macro
Working with VBA code

Printable course details

or equivalent knowledge.

7.5 hours

Individual Tuition

Group Training

Distance Learning

Prices

Distance Learning price

Excel VGA Programming

ECDL